﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title>Excel导入导出工资数据</title>
<style type="text/css">
    table,table tr th, table tr td { border:1px solid #0094ff;font-size: 12px; }
    table { width: 1200px; min-height: 25px; line-height: 25px; text-align: left; border-collapse: collapse;margin:0 auto;}
<!--
    .datable {background-color: #9FD6FF; color:#333333; font-size:12px;}
    .datable tr {height:20px;}
    .datable .lup {background-color: #C8E1FB;font-size: 12px;color: #014F8A;}
    .datable .lup th {font-weight: normal;}
    .datable .lupbai {background-color: #FFFFFF;}
    .datable .trnei {background-color: #F2F9FF;}
    .datable td {border-top: 1px solid #9FD6FF; border-left: 1px solid #9FD6FF; border-right: 1px solid #9FD6FF; border-bottom: 1px solid #9FD6FF;}
-->
</style>
</head>
<body>
    <form id="form1" runat="server">
    <div>    
        <table>
              <tr class="lupbai" >                  
                <td colspan="2">
                        操作说明：请先建工资表，再进行数据操作,工资表的操作，先导出模板，按模板说明填写内容，然后再导入工资数据，最后重算工资即可
                </td>
              </tr>
              <tr class="lupbai">
                <td width="20%">
                    选择信息</td><td>
                    选择部门：<asp:DropDownList ID="DropDownList1" runat="server"></asp:DropDownList><br />
                    选择月份：<asp:DropDownList ID="DropDownList2" runat="server"></asp:DropDownList><br />
                </td>
            </tr>
            <tr class="lupbai">
                <td width="20%">
                    1.新建工资表</td><td>                  
                    <asp:Button ID="Button7" runat="server" Text="新建工资表" OnClick="Button7_Click" />慎用，完全新建，所有数据重新录入<br />
                    <asp:Button ID="Button8" runat="server" Text="引用上月工资表" OnClick="Button8_Click" />引用上个月工资表员工信息，基本工资<br />
                    <asp:Button ID="Button9" runat="server" Text="插入新员工工资表" OnClick="Button9_Click" />插入新员工工资表员工信息<br />
                </td>
            </tr>

            <tr class="lupbai">
                <td width="20%">
                    2.计算考勤考核表</td><td>
                    <asp:Button ID="Button3" runat="server" OnClick="Button0_Click" Text="计算考勤" />
                </td>
            </tr>

            <tr class="lupbai">
                <td width="20%">
                    3.导出工资模板</td><td>
                    <asp:Button ID="Button5" runat="server" OnClick="Button1_Click" Text="导出工资模板" />
                </td>
            </tr>

            <tr class="lupbai">
                <td>4.选择工资数据Excel文件：</td><td>
                    <asp:FileUpload ID="FileUpload1" runat="server" /><br />
                    <asp:Button ID="Button1" runat="server" Text="预览" OnClick="Button2_Click" /><br />
                    <asp:Button ID="Button4" runat="server" Text="导入" OnClick="Button3_Click" /><br />
                </td>
            </tr>
            <tr class="lupbai">
                <td>5.工资数据重算：</td><td>
                    <asp:Button ID="Button6" runat="server" Text="重算数据" OnClick="Button4_Click" />
                </td>
            </tr>
            <tr class="lupbai">
                <td>6.导出工资表：</td><td>
                    <asp:Button ID="Button2" runat="server" Text="导出工资表" OnClick="Button5_Click" />
                </td>
            </tr>
            <tr class="lupbai">
                <td>7.删除工资表：</td><td>
                    <asp:Button ID="Button10" runat="server" Text="删除工资表" OnClick="Button10_Click" />
                </td>
            </tr>
            <tr class="lupbai">
                <td>99.职员信息导入：</td><td>
                    <asp:Button ID="Button11" runat="server" Text="导出模板" OnClick="Button11_Click" /><br />
                    <asp:FileUpload ID="FileUpload2" runat="server" /><br />
                    <asp:Button ID="Button12" runat="server" Text="预览" OnClick="Button12_Click" /><br />
                    <asp:Button ID="Button13" runat="server" Text="导入信息" OnClick="Button13_Click" /><br />
                </td>
            </tr>
        </table>
        <br />
        <table>
            <tr>
                <td><asp:Literal ID="ListText" runat="server"></asp:Literal></td>
            </tr>            
        </table>
        <br />
        <asp:GridView ID="GridView2" runat="server" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="4" Width="100%" ForeColor="Black" GridLines="Horizontal" AutoGenerateColumns="true">
        </asp:GridView>
        <asp:GridView ID="GridView1" runat="server"  Width="1200px"  CssClass="datable" CellPadding="2" CellSpacing="1" AutoGenerateColumns="true">
            <RowStyle CssClass="lupbai" />
            <HeaderStyle CssClass="lup" />
            <AlternatingRowStyle CssClass="trnei" />
        </asp:GridView>
            </div>
    </form>
</body>
</html>
